﻿EXCEL 2021:
Co-authoring
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly — in a matter of seconds.
LEARN MORE
Note: Co-authoring is not available in Excel LTSC 2021.
Better collaboration with modern comments
Have control of when you send comments to your co-authors and be productive with a consistent commenting experience in your workbooks and other Office apps.
LEARN MORE
Note: Modern comments is not available in Excel LTSC 2021.
 Working with a comment 

Know who's in your workbook
See who else is working along with you and where they are in the workbook.
Note: This feature is not available in Excel LTSC 2021.
 People icons, When others are co-authoring, they'll show up here 

Visual refresh
Work with a modernized Start experience and newly refreshed tabs in the ribbon. Experience a clean, clear style with monoline iconography, neutral color palette, and softer window corners. These updates communicate action and provide features with simple visuals.
Note: Visual refresh is not available in Excel LTSC 2021.
 Word, Excel, and PowerPoint displayed with visual updates in ribbon and rounded corners to match Windows 11 user interface. 

Look left, look right… XLOOKUP is here!
Row by row, find anything you need in a table or range with XLOOKUP​.
Return exact matches by default—there’s no need to specify​.
LEARN MORE
LET function
The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function.
Similar to variables in programming, LET is accomplished through Excel’s native formula syntax.
LEARN MORE
Dynamic arrays
Write one formula and return an array of values. Expedite calculations and insights with six ​
more new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
LEARN MORE
 Screenshot of Excel with data using dynamic arrays 

XMATCH function
The XMATCH function searches for a specified item in an array or range of cells, and then returns the item's relative position.
You can also use XMATCH to return a value in an array.
LEARN MORE
 Example of using XMATCH to find the position of an item in a list 

Sheet views
Create customized views in an Excel worksheet without disrupting others.
LEARN MORE
Note: Sheet views are not available in Excel LTSC 2021.
 The New button in the Sheet Views group 

A new way to reach the Accessibility tools
The Accessibility ribbon puts all the tools you need to create accessible content in one place.
LEARN MORE
Note: The Accessibility ribbon is not available in Excel LTSC 2021.
 Shows accessibility ribbon 

Increase the reach of your content
Accessibility Checker keeps an eye on your documents and tells you in the status bar when it finds something you should look at. Try it by clicking Review > Check Accessibility.
 Status bar showing that the Accessibility Checker is running 

Performance improvements
Experience improved performance, stability, and speed across Excel.
Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF​.
 Screenshot of Excel data using the SUMIF function 

Unhide many sheets at the same time
No need to unhide one sheet at a time anymore—unhide multiple hidden sheets at once.
LEARN MORE

See what’s new in stock media
We’re constantly adding more rich media content to the Office Premium Creative Content collection that helps you express yourself, such as a curated library of stock images, icons, and more.
LEARN MORE
Find what you need with Microsoft Search
At the top of your Microsoft Office apps on Windows, you'll find the new Microsoft Search box. This powerful tool helps you quickly find what you're looking for, such as text, commands, help, and more.
LEARN MORE
Save your changes as they happen
Upload your files to OneDrive, OneDrive for Business, or SharePoint Online to make sure all your updates are saved automatically.
LEARN MORE
Support for OpenDocument format (ODF) 1.3
We now include support for the OpenDocument format (ODF) 1.3. The ODF 1.3 specification adds support for many new features.
LEARN MORE
 List of file formats from Word with ODT file format highlighted 

Updated Draw tab
Quickly access and change the color of all your inking tools, all in one place.
Simplify how you work with ink using new Draw tab additions: Point Eraser, Ruler, and Lasso.
LEARN MORE
 Microsoft 365 Drawing Tools pens 

Get a quick summary of what’s in your workbook
Wondering how big your worksheet or workbook is getting? Excel provides workbook statistics to help you.
LEARN MORE
 The Workbook Statistics command on the Excel ribbon 

Pick the perfect color
Based on your feedback, we’ve added a new input field in the Colors dialog for Hex color values. No need to convert Hex color values into RGB values.
For any property where you can define a color, you can now enter a Hex color value in the Hex box, for example, #0F4C81 or 444.
 Shows Custom colors 

Try the Sketched style outline
You can give a casual, hand-drawn look to shapes in your workbook with the Sketched style outline.
Try out the Curved, Freehand, or Scribble options under Format Shape > Line > Sketched style
See the big picture with Navigation pane
Gain a clearer view of complex workbooks with the new Navigation pane feature. The Navigation pane is a great way to better understand a workbook’s layout, view the different elements that make up the workbook, and navigate directly to those elements. To try out the feature, select the View tab and then choose the Navigation button to open the pane (or select the sequence Alt > W > K to open the pane from your keyboard).
Improved scrolling in sheets with large cells
When you are using a sheet with very large cells, sometimes the “snap to grid” functionality in Excel can make it harder to view the data you want. We’ve fixed this issue by making the scrolling much smoother—no more snapping to rows and columns. You’re now able to stop scrolling partially through a row or column, and Excel will not force the sheet to snap to the edges.
* We fixed an issue with switching separators after a Selection.Parent.Copy call.
* We fixed an issue where Excel was clearing out the value for HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Common\UserInfo\Company in non-MSI installs of Office.
* We fixed an issue that caused the trend line on charts with logarithmic data to not be smooth.
* We fixed an issue with the Insert Cells dialog in which double-clicking on one of the options was not applying the selected option and dismissing the dialog.
* We fixed an issue where scrolling using a mouse wheel or touch pad wasn’t working if the last row or column in the sheet was hidden.
* We fixed a problem where the Analysis ToolPak add-in did not work with certain Automation Security settings.
* We fixed an issue where, under rare circumstances, Excel could stop responding while calculating a workbook.
* We fixed a rendering issue in worksheets with Freeze Panes enabled for certain scrolling scenarios.
* We fixed an issue where localized characters appeared lower than English characters in the sheet tabs.
* We fixed an issue where the Find/Replace dialog only saved history for Find and not Replace (the dialog was not saving the history of what was replaced when Replace occurred).
* We fixed an issue where automatic sensitivity labeling was not working for a few GCC-H tenants.
* We fixed an issue that caused an insufficient memory warning to appear when copying and pasting content.
* We fixed an issue where the error ERROR_DISK_FULL would appear before maintenance would begin.
* We fixed an issue where Excel’s enclosed numeric characters showed as question marks.
* We fixed an issue where the row and column header colors on partial selection were not discernible from the fishbowl color in Dark Gray theme (only present for users with the Fluent UI Coming Soon toggle enabled).
* We fixed an issue where users reported it was difficult to tell the selected tabs from the non-selected tabs in the Office light themes (issue only present for users with the Fluent UI Coming soon toggle enabled).
* We fixed an issue in the Excel macro language in which the alert dialog box did not show in the proper type.
* We fixed an issue with number formats used in Data Type property values for non-English regional system settings.
* We fixed an issue where, in some cases, the top rows could appear duplicated in worksheets with Freeze Panes enabled.
* We fixed an issue where the BizUD Gothic Japanese font was rendering differently between Office applications.
* We fixed an issue where using a cell reference in a formula caused users to experience high CPU usage.